package cemp.mapper;

import cemp.entity.StockKpiDay;
import cemp.entity.StockSysUser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
* @author xsb_t
* @description 针对表【stock_sys_user】的数据库操作Mapper
* @createDate 2025-01-12 14:18:26
* @Entity cemp.entity.StockSysUser
*/
public interface StockSysUserMapper extends BaseMapper<StockSysUser> {

    @Select("select * from stock_sys_user t1 where t1.email =#{username} || t1.mobile = #{username} || t1.username = #{username} limit 1")
    StockSysUser getByName( @Param("username")String username);


    @Select("select * from stock_sys_user t1 where t1.mobile =#{phoneNumber} limit 1")
    StockSysUser getByPhone( @Param("phoneNumber")String phoneNumber);



}




